Dashboard 02 - WakeCountyRealEstate Dashboard - Creating Cards and Slicer
15
Step 1a: Create Township Name Card
In Power BI Desktop, click on the page, WakeCountyRealEstate
Click inside the pane
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Measure_Township
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Township Name
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 1061 , Y Position = 121 , Width = 438 , Height = 52
Under Format -> Data Label -> Color = #945231 , Text Size = 25 pt , Font = DIN (default)
Under Format -> Category -> Set it to OFF
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = #CCCCCC
Step 1b: Create a blank text box
As part of the cards, there needs to be a blank text box.
Click on the Insert ribbon -> Text box
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Township Name
Under Format -> General: X Position = 272 , Y Position = 120 , Width = 789 , Height = 52
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = #CCCCCC, Radius = 0 px
All other visualizations settings are set to OFF.
Step 2: Create Average House Prices Card
Click inside the pane
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_AVG_Residentials_Prices
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card = AVG House Prices
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 0 , Y Position = 172, Width = 272 , Height = 159
Under Format -> Data Label -> Color = #000000 , Text Size = 25 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = #945231 , Text Size = 17 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = #E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px

Step 3: Create AVG Price House Price/Sq.Ft. Card
To create remainder of the cards, copy and paste the AVG Price House Price/Sq.Ft. Card that was created in Step 2 and use it as a template.
Click the AVG House Price Card icon , press Ctrl+C to copy the card , press Ctrl+V to paste
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_AVG_ResidentialPrice_PerSqFt
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card = AVG Price House Price/Sq.Ft.
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 0 , Y Position = 331, Width = 272 , Height = 155
Under Format -> Data Label -> Color = #000000 , Text Size = 25 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = #945231 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = #E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px

Step 4: Create AVG Apt Price/Sq.Ft. Card
To create the following card, copy and paste the AVG Price House Price/Sq.Ft. Card that was created in Step 3 and use it as a template.
Click the AVG House Price Card icon , press Ctrl+C to copy the card , press Ctrl+V to paste
Fields
Select the following:
A_KeyMeasures -> .Transparent_AVG_AptUnitPrice_PerSqFt
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card = AVG Apt Price/Sq.Ft.
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 0 , Y Position = 640 , Width = 272 , Height = 155
Under Format -> Data Label -> Color = #000000 , Text Size = 25 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = ##1D0C4A , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = #E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px

Step 5: Create YOY AVG Hse Price/Sq.Ft. Card
To create the following card, copy and paste the AVG Price House Price/Sq.Ft. Card that was created in Step 3 and use it as a template.
Click the AVG House Price Card icon , press Ctrl+C to copy the card , press Ctrl+V to paste
Fields
Select the following:
A_KeyMeasures -> .Transparent_YOY_AVG_ResidentialPrice_PerSqFt
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card = YOY AVG Hse Price/Sq.Ft.
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 0 , Y Position = 485 , Width = 272 , Height = 155
Under Format -> Data Label -> Color = click on the letters
fx -> Format by = Color Scale , Based on field = .YOY_AVG_ResidentialPrice_PerSqFt% , Minimum = Custom = 0.00001 & color = #FF0000 , Maximum = 0 & color = #5B8F22 , Text Size = 25 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = #945231 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = #E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px


Step 6: Create YOY AVG Apt Price/Sq.Ft. Card
To create the following card, copy and paste the AVG Price House Price/Sq.Ft. Card that was created in Step 3 and use it as a template.
Click the AVG House Price Card icon , press Ctrl+C to copy the card , press Ctrl+V to paste
Fields
Select the following:
A_KeyMeasures -> .Transparent_YOY_AVG_AptUnitPrice_PerSqFt
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card = YOY AVG Apt Price/Sq.Ft.
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 0 , Y Position = 796 , Width = 272 , Height = 155
Under Format -> Data Label -> Color = click on the letters
fx -> Format by = Color Scale , Based on field = .YOY_AVG_AptUnitPrice_PerSqFt% , Minimum = Custom = 0.00001 & color = #FF0000 , Maximum = 0 & color = #5B8F22 , Text Size = 25 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = #1D0C4A , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = #E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px

Step 7: Create Year SlicerIf selected, de-select a visualization by clicking an empty area of the report page.
VisualizationsClick the Slicer icon
FieldsSelect the following:
DateDimension -> Date -> Date Hierarchy -> Year
Visualizations
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General -> Outline Color = #605E5C , X Position = 1018 , Y Position = 0 , Width = 300 , Height = 120
Under Format -> Slider header -> Set it to ON -> Title Text = Years , Color = #252423 , Text Size = 12
Under Format -> Numeric Inputs -> Font Color = #252423, Text Size = 15 pt , Font = Segoe UI
Under Format -> Slider -> Set it to ON -> Color = #094780
Under Format -> Title -> Set it to ON , Title Text = Years, Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)
Under Format -> Background -> Set it to ON , Color = #FFFFFF
Under Format -> Border -> Set it to ON , Color = 666666 , Radius 5 px

Step 8: Create Last Refresh Date cardTo create the following card to show the last time the dataset was refreshed, copy and paste the AVG House Price Card that was created in Step 3 and use it as a template.
To create a copy of the visual, click the AVG House Price Card visualization , press Ctrl+C to copy, and then press Ctrl+V to paste
FieldsSelect the following:
A_KeyMeasures -> .Last_Refreshed_Date
Visualizations
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card = Last Refresh Date
Under Format -> General: X Position = 0 , Y Position = 951 , Width = 272 , Height = 101
Under Format -> Data Label -> Color = #000000 , Text Size = 22 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = #1D0C4A , Text Size = 17 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = #E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px

When finished, save the project.
How to create a Card visualization in Power BI
How to create a Slicer visualization in Power BI